The CTime and Time functions are equivalent to TimeValue. However, Time can only be used in Crystal syntax since it is a type name in Basic syntax.
Returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive. | |
TimeValue (number) returns a Time value given a number in units of 24 hours. The number can be negative or fractional as well.
TimeValue (string) returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.
TimeValue (dateTime) returns the time portion of a given DateTime value.
TimeValue (HH, MM, SS) returns a Time value given numeric arguments of the hour, minute and seconds.
The following examples are applicable to both Basic and Crystal syntax:
TimeValue (.2) TimeValue (1.2)
Both return the same value 4:48:00 a.m.
TimeValue ("Jan. 6, 1999 2:30pm")
TimeValue (#Feb. 24, 1999 2:40pm#)
You can use the IsTime function to check if a string argument can be converted to a Time before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately. See alsoTimeSerial (hour, minute, second).
Seagate Software IMG Holdings, Inc. http://www.seagatesoftware.com Support services: http://support.seagatesoftware.com |